The Judicial Branch Purchasing Services office is posting the attached Statement of Work (SOW) to fill a Solution Architect position for Judicial’s Court Support Services Division (CSSD).  The position includes an initial requirement to be in-office and remote work thereafter with approval from a Project Manager.  The SOW describing the complete details of the position is attached. Please review carefully. 

Agencies must ensure that candidates whose resumes are submitted to the Judicial Branch are fully aware of the requirements of the position, including but not limited to any noted limitations regarding remote work and requirements regarding the submittal of on-boarding documents.   

Scope of Services:

The State of Connecticut Judicial Branch, Court Support Services Division (CSSD) is seeking a Solution Architect to lead various information technology and business intelligence efforts inCSSD. The successful candidate will be a passionate data professional who can identify strategies and best practices and provide direction and support to a team of BI/DW developers.

Minimum Qualifications:

The minimum skills and experience level required for a candidate to be considered for this position include:

• A self-starter with strong analytical and problem-solving ability

• Experience providing guidance and leadership to technical staff

• Minimum of 9 years’ experience as a data warehouse developer/database developer

• Minimum of 5 years’ experience architecting data models

• Thorough understanding of data warehousing concepts, Star Schema design, and slowly changing dimensions

• Minimum of 5 years’ experience analyzing administrative datasets

• Minimum of 9 years’ experience with MS SQL Server 2016/2019/2022 including T-SQL programming and scripting

• Minimum of 9 years’ experience building Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft Business Intelligence technology stack (SSRS, SSIS, SSAS), Power BI, Tableau, or other

visualization technology

• Minimum of 5 years’ experience assembling and validating large datasets for research/analysis

• Have experience identifying data acquisition strategies, designing Master Data Management solutions, and implementing data governance processes

• Minimum of 5 years’ experience working with data in Excel

• Minimum of 9 years’ experience in gathering and analyzing business requirements

• Ability to work with staff of varying skill levels, both technical and non-technical

• Strong communications skills including written, verbal, presentation and interpersonal

• Proven ability to produce quality work independently, with minimal supervision

• Proven ability to handle multiple projects simultaneously

Timetable:

• The service of this individual will be required 40 hours per week for 6 months, with possible extension, commencing on or about February 10, 2025.
• IT consultants will be required to attend their first two (2) days in-person in Glastonbury CT.
• The Judicial Branch does not have funds to reimburse for any travel expenses. Thereafter, consultants are currently allowed to work 100% remotely with the Project Manager’s approval.